Excel 2010 Just the Steps For Dummies by Diane Koers

Author:Diane Koers
Language: eng
Format: epub, pdf
Publisher: Wiley
Published: 2010-04-26T16:00:00+00:00

Figure 11-11

Figure 11-12

Search for Data

1. Choose Home⇒Find & Select⇒Find in the Editing group. The Find and Replace dialog box appears.

Alternatively, press Ctrl+F to open the Find and Replace dialog box.

2. In the Find What box, enter the value or word you want to locate.

3. Click the Options button and specify any desired options, as shown in Figure 11-13:

• Within: Search just the current worksheet or the entire workbook.

• Search: Select whether to search first across the rows or down the columns.

• Look In: Select whether you want to search through the values or formula results, through the actual formulas, or if you want to look in the comments.

Choose Formulas in the Look In drop-down list when you’re looking for a formula that references a specific cell address.

• Match Case: Select this check box if you want your search to be case-specific (for example, BOBCAT instead of BobCat or Bobcat).

• Match Entire Cell Contents: Select this check box if you want your search results to list only the items that exactly match your search criteria.

4. Click the Find Next button. Excel jumps to the first occurrence of the match (see Figure 11-14). If this isn’t the entry you’re looking for, click the Find Next button again. Excel advises you if it doesn’t locate the data you are searching for.

5. Click the Close button when you’ve located the entry you want.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.